Dataset info
| Number of variables | 60 |
|---|---|
| Number of observations | 192609 |
| Missing cells | 6754992 (58.5%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 88.2 MiB |
| Average record size in memory | 480.0 B |
Variables types
| Numeric | 4 |
|---|---|
| Categorical | 42 |
| Boolean | 5 |
| Date | 0 |
| URL | 0 |
| Text (Unique) | 1 |
| Rejected | 0 |
| Unsupported | 8 |
Warnings
address has a high cardinality: 151977 distinct values | Warning |
address has 7682 (4.0%) missing values | Missing |
attributes has a high cardinality: 93977 distinct values | Warning |
attributes has 28836 (15.0%) missing values | Missing |
attributes.AcceptsInsurance is an unsupported type, check if it needs cleaning or further analysis | Warning |
attributes.AgesAllowed has 192486 (99.9%) missing values | Missing |
attributes.Alcohol has 144146 (74.8%) missing values | Missing |
attributes.Ambience has a high cardinality: 383 distinct values | Warning |
attributes.Ambience has 144530 (75.0%) missing values | Missing |
attributes.BestNights has a high cardinality: 66 distinct values | Warning |
attributes.BestNights has 189133 (98.2%) missing values | Missing |
attributes.BikeParking has 107210 (55.7%) missing values | Missing |
attributes.BusinessAcceptsBitcoin is an unsupported type, check if it needs cleaning or further analysis | Warning |
attributes.BusinessAcceptsCreditCards has 79476 (41.3%) missing values | Missing |
attributes.BusinessParking has 88896 (46.2%) missing values | Missing |
attributes.ByAppointmentOnly has 145756 (75.7%) missing values | Missing |
attributes.BYOB has 192581 (> 99.9%) missing values | Missing |
attributes.BYOBCorkage has 191186 (99.3%) missing values | Missing |
attributes.Caters has 151981 (78.9%) missing values | Missing |
attributes.CoatCheck is an unsupported type, check if it needs cleaning or further analysis | Warning |
attributes.Corkage has 191947 (99.7%) missing values | Missing |
attributes.DietaryRestrictions has 192550 (> 99.9%) missing values | Missing |
attributes.DogsAllowed is an unsupported type, check if it needs cleaning or further analysis | Warning |
attributes.DriveThru is an unsupported type, check if it needs cleaning or further analysis | Warning |
attributes.GoodForDancing is an unsupported type, check if it needs cleaning or further analysis | Warning |
attributes.GoodForKids has 126299 (65.6%) missing values | Missing |
attributes.GoodForMeal has a high cardinality: 77 distinct values | Warning |
attributes.GoodForMeal has 162683 (84.5%) missing values | Missing |
attributes.HairSpecializesIn has a high cardinality: 129 distinct values | Warning |
attributes.HairSpecializesIn has 191603 (99.5%) missing values | Missing |
attributes.HappyHour is an unsupported type, check if it needs cleaning or further analysis | Warning |
attributes.HasTV has 144511 (75.0%) missing values | Missing |
attributes.Music has a high cardinality: 87 distinct values | Warning |
attributes.Music has 187360 (97.3%) missing values | Missing |
attributes.NoiseLevel has 148730 (77.2%) missing values | Missing |
attributes.Open24Hours has 192596 (> 99.9%) missing values | Missing |
attributes.OutdoorSeating has 137786 (71.5%) missing values | Missing |
attributes.RestaurantsAttire has 143970 (74.7%) missing values | Missing |
attributes.RestaurantsCounterService has 192598 (> 99.9%) missing values | Missing |
attributes.RestaurantsDelivery has 140087 (72.7%) missing values | Missing |
attributes.RestaurantsGoodForGroups has 137891 (71.6%) missing values | Missing |
attributes.RestaurantsPriceRange2 has 84430 (43.8%) missing values | Missing |
attributes.RestaurantsReservations has 140322 (72.9%) missing values | Missing |
attributes.RestaurantsTableService is an unsupported type, check if it needs cleaning or further analysis | Warning |
attributes.RestaurantsTakeOut has 130532 (67.8%) missing values | Missing |
attributes.Smoking has 189111 (98.2%) missing values | Missing |
attributes.WheelchairAccessible has 172650 (89.6%) missing values | Missing |
attributes.WiFi has 142545 (74.0%) missing values | Missing |
categories has a high cardinality: 93386 distinct values | Warning |
city has a high cardinality: 1204 distinct values | Warning |
hours has a high cardinality: 51567 distinct values | Warning |
hours has 44830 (23.3%) missing values | Missing |
hours.Friday has a high cardinality: 1565 distinct values | Warning |
hours.Friday has 47435 (24.6%) missing values | Missing |
hours.Monday has a high cardinality: 1399 distinct values | Warning |
hours.Monday has 56842 (29.5%) missing values | Missing |
hours.Saturday has a high cardinality: 1506 distinct values | Warning |
hours.Saturday has 66748 (34.7%) missing values | Missing |
hours.Sunday has a high cardinality: 1365 distinct values | Warning |
hours.Sunday has 101273 (52.6%) missing values | Missing |
hours.Thursday has a high cardinality: 1525 distinct values | Warning |
hours.Thursday has 46706 (24.2%) missing values | Missing |
hours.Tuesday has a high cardinality: 1445 distinct values | Warning |
hours.Tuesday has 49181 (25.5%) missing values | Missing |
hours.Wednesday has a high cardinality: 1461 distinct values | Warning |
hours.Wednesday has 47452 (24.6%) missing values | Missing |
name has a high cardinality: 145046 distinct values | Warning |
postal_code has a high cardinality: 17541 distinct values | Warning |
address
Categorical
| Distinct count | 151977 |
|---|---|
| Unique (%) | 78.9% |
| Missing (%) | 4.0% |
| Missing (n) | 7682 |
| 5757 Wayne Newton Blvd | 96 |
|---|---|
| 7014 E Camelback Rd | 79 |
| 3200 Las Vegas Blvd S | 78 |
| Other values (151973) | |
| (Missing) | 7682 |
| Value | Count | Frequency (%) | |
| 5757 Wayne Newton Blvd | 96 | < 0.1% | |
| 7014 E Camelback Rd | 79 | < 0.1% | |
| 3200 Las Vegas Blvd S | 78 | < 0.1% | |
| 3111 W Chandler Blvd | 74 | < 0.1% | |
| 4400 Sharon Rd | 70 | < 0.1% | |
| 5000 S Arizona Mills Cir | 68 | < 0.1% | |
| 100 City Centre Drive | 67 | < 0.1% | |
| 3500 Las Vegas Blvd S | 66 | < 0.1% | |
| 3401 Dufferin Street | 63 | < 0.1% | |
| 3799 Las Vegas Blvd S | 61 | < 0.1% | |
| Other values (151966) | 184205 | 95.6% | |
| (Missing) | 7682 | 4.0% |
| Max length | 118 |
|---|---|
| Mean length | 20.30478846 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
attributes
Categorical
| Distinct count | 93977 |
|---|---|
| Unique (%) | 48.8% |
| Missing (%) | 15.0% |
| Missing (n) | 28836 |
| {'BusinessAcceptsCreditCards': 'True'} | 13109 |
|---|---|
| {'ByAppointmentOnly': 'True'} | 2818 |
| {'ByAppointmentOnly': 'True', 'BusinessAcceptsCreditCards': 'True'} | 2360 |
| Other values (93973) | |
| (Missing) | 28836 |
| Value | Count | Frequency (%) | |
| {'BusinessAcceptsCreditCards': 'True'} | 13109 | 6.8% | |
| {'ByAppointmentOnly': 'True'} | 2818 | 1.5% | |
| {'ByAppointmentOnly': 'True', 'BusinessAcceptsCreditCards': 'True'} | 2360 | 1.2% | |
| {'BusinessAcceptsCreditCards': 'True', 'ByAppointmentOnly': 'True'} | 2279 | 1.2% | |
| {'GoodForKids': 'True'} | 2230 | 1.2% | |
| {'ByAppointmentOnly': 'False', 'BusinessAcceptsCreditCards': 'True'} | 1564 | 0.8% | |
| {'BusinessAcceptsCreditCards': 'True', 'ByAppointmentOnly': 'False'} | 1562 | 0.8% | |
| {'BusinessAcceptsCreditCards': 'False'} | 1336 | 0.7% | |
| {'ByAppointmentOnly': 'False'} | 1075 | 0.6% | |
| {'GoodForKids': 'False'} | 859 | 0.4% | |
| Other values (93966) | 134581 | 69.9% | |
| (Missing) | 28836 | 15.0% |
| Max length | 1609 |
|---|---|
| Mean length | 283.8301014 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
attributes.AcceptsInsurance
Unsupported
This variable is an unsupported type, check if it needs cleaning or further analysis
| Unsupported value |
|---|
attributes.AgesAllowed
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 99.9% |
| Missing (n) | 192486 |
| u'21plus' | 71 |
|---|---|
| u'allages' | 18 |
| u'19plus' | 16 |
| Other values (2) | 18 |
| (Missing) |
| Value | Count | Frequency (%) | |
| u'21plus' | 71 | < 0.1% | |
| u'allages' | 18 | < 0.1% | |
| u'19plus' | 16 | < 0.1% | |
| u'18plus' | 15 | < 0.1% | |
| None | 3 | < 0.1% | |
| (Missing) | 192486 | 99.9% |
| Max length | 10 |
|---|---|
| Mean length | 3.003847172 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
attributes.Alcohol
Categorical
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 74.8% |
| Missing (n) | 144146 |
| u'full_bar' | 16516 |
|---|---|
| u'none' | 15714 |
| 'none' | 5954 |
| Other values (4) | 10279 |
| (Missing) |
| Value | Count | Frequency (%) | |
| u'full_bar' | 16516 | 8.6% | |
| u'none' | 15714 | 8.2% | |
| 'none' | 5954 | 3.1% | |
| u'beer_and_wine' | 4669 | 2.4% | |
| 'full_bar' | 3621 | 1.9% | |
| 'beer_and_wine' | 1909 | 1.0% | |
| None | 80 | < 0.1% | |
| (Missing) | 144146 | 74.8% |
| Max length | 16 |
|---|---|
| Mean length | 4.671147246 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | True |
attributes.Ambience
Categorical
| Distinct count | 383 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 75.0% |
| Missing (n) | 144530 |
| {'romantic': False, 'intimate': False, 'classy': False, 'hipster': False, 'divey': False, 'touristy': False, 'trendy': False, 'upscale': False, 'casual': True} | 9935 |
|---|---|
| {'romantic': False, 'intimate': False, 'classy': False, 'hipster': False, 'divey': False, 'touristy': False, 'trendy': False, 'upscale': False, 'casual': False} | 8982 |
| {'romantic': False, 'intimate': False, 'touristy': False, 'hipster': False, 'divey': False, 'classy': False, 'trendy': False, 'upscale': False, 'casual': True} | 5610 |
| Other values (379) | 23552 |
| (Missing) |
| Value | Count | Frequency (%) | |
| {'romantic': False, 'intimate': False, 'classy': False, 'hipster': False, 'divey': False, 'touristy': False, 'trendy': False, 'upscale': False, 'casual': True} | 9935 | 5.2% | |
| {'romantic': False, 'intimate': False, 'classy': False, 'hipster': False, 'divey': False, 'touristy': False, 'trendy': False, 'upscale': False, 'casual': False} | 8982 | 4.7% | |
| {'romantic': False, 'intimate': False, 'touristy': False, 'hipster': False, 'divey': False, 'classy': False, 'trendy': False, 'upscale': False, 'casual': True} | 5610 | 2.9% | |
| {'touristy': False, 'hipster': False, 'romantic': False, 'divey': False, 'intimate': False, 'trendy': False, 'upscale': False, 'classy': False, 'casual': False} | 3856 | 2.0% | |
| {'touristy': False, 'hipster': False, 'romantic': False, 'intimate': False, 'trendy': False, 'upscale': False, 'classy': False, 'casual': False} | 3311 | 1.7% | |
| {'touristy': False, 'hipster': False, 'romantic': False, 'divey': False, 'intimate': False, 'trendy': False, 'upscale': False, 'classy': False, 'casual': True} | 3041 | 1.6% | |
| {'romantic': False, 'intimate': False, 'touristy': False, 'hipster': False, 'divey': False, 'classy': False, 'trendy': False, 'upscale': False, 'casual': False} | 2949 | 1.5% | |
| {'touristy': False, 'hipster': False, 'romantic': False, 'intimate': False, 'trendy': False, 'upscale': False, 'classy': False, 'casual': True} | 1362 | 0.7% | |
| {'romantic': False, 'intimate': False, 'classy': False, 'hipster': False, 'touristy': False, 'trendy': False, 'upscale': False, 'casual': False} | 794 | 0.4% | |
| {'touristy': False, 'hipster': False, 'romantic': False, 'divey': False, 'intimate': False, 'trendy': True, 'upscale': False, 'classy': False, 'casual': True} | 593 | 0.3% | |
| Other values (372) | 7646 | 4.0% | |
| (Missing) | 144530 | 75.0% |
| Max length | 160 |
|---|---|
| Mean length | 40.88738844 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
attributes.BestNights
Categorical
| Distinct count | 66 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 98.2% |
| Missing (n) | 189133 |
| {'monday': False, 'tuesday': False, 'friday': True, 'wednesday': False, 'thursday': True, 'sunday': False, 'saturday': True} | 767 |
|---|---|
| {'monday': False, 'tuesday': False, 'friday': True, 'wednesday': False, 'thursday': False, 'sunday': True, 'saturday': True} | 533 |
| {'monday': False, 'tuesday': False, 'friday': True, 'wednesday': False, 'thursday': False, 'sunday': False, 'saturday': True} | 231 |
| Other values (62) | 1945 |
| (Missing) |
| Value | Count | Frequency (%) | |
| {'monday': False, 'tuesday': False, 'friday': True, 'wednesday': False, 'thursday': True, 'sunday': False, 'saturday': True} | 767 | 0.4% | |
| {'monday': False, 'tuesday': False, 'friday': True, 'wednesday': False, 'thursday': False, 'sunday': True, 'saturday': True} | 533 | 0.3% | |
| {'monday': False, 'tuesday': False, 'friday': True, 'wednesday': False, 'thursday': False, 'sunday': False, 'saturday': True} | 231 | 0.1% | |
| {'monday': False, 'tuesday': False, 'friday': False, 'wednesday': False, 'thursday': False, 'sunday': False, 'saturday': False} | 230 | 0.1% | |
| {'monday': False, 'tuesday': False, 'friday': False, 'wednesday': False, 'thursday': False, 'sunday': False, 'saturday': True} | 184 | 0.1% | |
| {'monday': False, 'tuesday': False, 'friday': True, 'wednesday': False, 'thursday': False, 'sunday': False, 'saturday': False} | 182 | 0.1% | |
| {'monday': False, 'tuesday': False, 'friday': True, 'wednesday': True, 'thursday': False, 'sunday': False, 'saturday': True} | 181 | 0.1% | |
| {'monday': True, 'tuesday': False, 'friday': True, 'wednesday': False, 'thursday': False, 'sunday': False, 'saturday': True} | 122 | 0.1% | |
| {'monday': False, 'tuesday': True, 'friday': True, 'wednesday': False, 'thursday': False, 'sunday': False, 'saturday': True} | 105 | 0.1% | |
| {'monday': False, 'tuesday': False, 'friday': False, 'wednesday': True, 'thursday': True, 'sunday': False, 'saturday': True} | 64 | < 0.1% | |
| Other values (55) | 877 | 0.5% | |
| (Missing) | 189133 | 98.2% |
| Max length | 127 |
|---|---|
| Mean length | 5.191091797 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
attributes.BikeParking
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 55.7% |
| Missing (n) | 107210 |
| True | |
|---|---|
| False | 18880 |
| None | 188 |
| (Missing) |
| Value | Count | Frequency (%) | |
| True | 66331 | 34.4% | |
| False | 18880 | 9.8% | |
| None | 188 | 0.1% | |
| (Missing) | 107210 | 55.7% |
| Max length | 5 |
|---|---|
| Mean length | 3.541402531 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
attributes.BusinessAcceptsBitcoin
Unsupported
This variable is an unsupported type, check if it needs cleaning or further analysis
| Unsupported value |
|---|
attributes.BusinessAcceptsCreditCards
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 41.3% |
| Missing (n) | 79476 |
| True | |
|---|---|
| False | 6045 |
| None | 114 |
| (Missing) |
| Value | Count | Frequency (%) | |
| True | 106974 | 55.5% | |
| False | 6045 | 3.1% | |
| None | 114 | 0.1% | |
| (Missing) | 79476 | 41.3% |
| Max length | 5 |
|---|---|
| Mean length | 3.618756133 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
attributes.BusinessParking
Categorical
| Distinct count | 46 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 46.2% |
| Missing (n) | 88896 |
| {'garage': False, 'street': False, 'validated': False, 'lot': False, 'valet': False} | |
|---|---|
| {'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False} | |
| {'garage': False, 'street': True, 'validated': False, 'lot': False, 'valet': False} | 14061 |
| Other values (42) | 12465 |
| (Missing) |
| Value | Count | Frequency (%) | |
| {'garage': False, 'street': False, 'validated': False, 'lot': False, 'valet': False} | 40150 | 20.8% | |
| {'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False} | 37037 | 19.2% | |
| {'garage': False, 'street': True, 'validated': False, 'lot': False, 'valet': False} | 14061 | 7.3% | |
| {'garage': False, 'street': True, 'validated': False, 'lot': True, 'valet': False} | 3204 | 1.7% | |
| {'garage': True, 'street': False, 'validated': False, 'lot': False, 'valet': False} | 2609 | 1.4% | |
| None | 2235 | 1.2% | |
| {'garage': True, 'street': True, 'validated': False, 'lot': False, 'valet': False} | 1061 | 0.6% | |
| {'garage': True, 'street': False, 'validated': False, 'lot': False, 'valet': True} | 604 | 0.3% | |
| {'garage': True, 'street': False, 'validated': False, 'lot': True, 'valet': False} | 397 | 0.2% | |
| {'garage': False, 'street': False, 'validated': False, 'lot': False, 'valet': True} | 339 | 0.2% | |
| Other values (35) | 2016 | 1.0% | |
| (Missing) | 88896 | 46.2% |
| Max length | 84 |
|---|---|
| Mean length | 45.30923789 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
attributes.ByAppointmentOnly
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 75.7% |
| Missing (n) | 145756 |
| False | 24385 |
|---|---|
| True | 22344 |
| None | 124 |
| (Missing) |
| Value | Count | Frequency (%) | |
| False | 24385 | 12.7% | |
| True | 22344 | 11.6% | |
| None | 124 | 0.1% | |
| (Missing) | 145756 | 75.7% |
| Max length | 5 |
|---|---|
| Mean length | 3.369858106 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
attributes.BYOB
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | > 99.9% |
| Missing (n) | 192581 |
| False | 27 |
|---|---|
| True | 1 |
| (Missing) |
| Value | Count | Frequency (%) | |
| False | 27 | < 0.1% | |
| True | 1 | < 0.1% | |
| (Missing) | 192581 | > 99.9% |
attributes.BYOBCorkage
Categorical
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 99.3% |
| Missing (n) | 191186 |
| 'no' | 757 |
|---|---|
| 'yes_free' | 498 |
| 'yes_corkage' | 145 |
| Other values (4) | 23 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 'no' | 757 | 0.4% | |
| 'yes_free' | 498 | 0.3% | |
| 'yes_corkage' | 145 | 0.1% | |
| u'yes_corkage' | 13 | < 0.1% | |
| u'no' | 5 | < 0.1% | |
| None | 3 | < 0.1% | |
| u'yes_free' | 2 | < 0.1% | |
| (Missing) | 191186 | 99.3% |
| Max length | 14 |
|---|---|
| Mean length | 3.03045029 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | True |
attributes.Caters
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 78.9% |
| Missing (n) | 151981 |
| True | 20666 |
|---|---|
| False | 19829 |
| None | 133 |
| (Missing) |
| Value | Count | Frequency (%) | |
| True | 20666 | 10.7% | |
| False | 19829 | 10.3% | |
| None | 133 | 0.1% | |
| (Missing) | 151981 | 78.9% |
| Max length | 5 |
|---|---|
| Mean length | 3.313884606 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
attributes.CoatCheck
Unsupported
This variable is an unsupported type, check if it needs cleaning or further analysis
| Unsupported value |
|---|
attributes.Corkage
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 99.7% |
| Missing (n) | 191947 |
| False | 524 |
|---|---|
| True | 138 |
| (Missing) |
| Value | Count | Frequency (%) | |
| False | 524 | 0.3% | |
| True | 138 | 0.1% | |
| (Missing) | 191947 | 99.7% |
attributes.DietaryRestrictions
Categorical
| Distinct count | 12 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | > 99.9% |
| Missing (n) | 192550 |
| {'dairy-free': False, 'gluten-free': False, 'vegan': True, 'kosher': False, 'halal': False, 'soy-free': False, 'vegetarian': False} | 13 |
|---|---|
| {'dairy-free': False, 'gluten-free': True, 'vegan': False, 'kosher': False, 'halal': False, 'soy-free': False, 'vegetarian': False} | 13 |
| {'dairy-free': False, 'gluten-free': False, 'vegan': False, 'kosher': False, 'halal': False, 'soy-free': False, 'vegetarian': True} | 7 |
| Other values (8) | 26 |
| (Missing) |
| Value | Count | Frequency (%) | |
| {'dairy-free': False, 'gluten-free': False, 'vegan': True, 'kosher': False, 'halal': False, 'soy-free': False, 'vegetarian': False} | 13 | < 0.1% | |
| {'dairy-free': False, 'gluten-free': True, 'vegan': False, 'kosher': False, 'halal': False, 'soy-free': False, 'vegetarian': False} | 13 | < 0.1% | |
| {'dairy-free': False, 'gluten-free': False, 'vegan': False, 'kosher': False, 'halal': False, 'soy-free': False, 'vegetarian': True} | 7 | < 0.1% | |
| None | 7 | < 0.1% | |
| {'dairy-free': False, 'gluten-free': True, 'vegan': True, 'kosher': False, 'halal': False, 'soy-free': False, 'vegetarian': False} | 6 | < 0.1% | |
| {'dairy-free': False, 'gluten-free': False, 'vegan': True, 'kosher': False, 'halal': False, 'soy-free': False, 'vegetarian': True} | 4 | < 0.1% | |
| {'dairy-free': False, 'gluten-free': False, 'vegan': False, 'kosher': False, 'halal': True, 'soy-free': False, 'vegetarian': False} | 3 | < 0.1% | |
| {'dairy-free': False, 'gluten-free': True, 'vegan': True, 'kosher': False, 'halal': False, 'soy-free': False, 'vegetarian': True} | 2 | < 0.1% | |
| {'dairy-free': False, 'gluten-free': True, 'vegan': False, 'kosher': False, 'halal': False, 'soy-free': False, 'vegetarian': True} | 2 | < 0.1% | |
| {'dairy-free': True, 'gluten-free': True, 'vegan': True, 'kosher': False, 'halal': False, 'soy-free': True, 'vegetarian': True} | 1 | < 0.1% | |
| (Missing) | 192550 | > 99.9% |
| Max length | 131 |
|---|---|
| Mean length | 3.034479178 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
attributes.DogsAllowed
Unsupported
This variable is an unsupported type, check if it needs cleaning or further analysis
| Unsupported value |
|---|
attributes.DriveThru
Unsupported
This variable is an unsupported type, check if it needs cleaning or further analysis
| Unsupported value |
|---|
attributes.GoodForDancing
Unsupported
This variable is an unsupported type, check if it needs cleaning or further analysis
| Unsupported value |
|---|
attributes.GoodForKids
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 65.6% |
| Missing (n) | 126299 |
| True | |
|---|---|
| False | 12917 |
| None | 63 |
| (Missing) |
| Value | Count | Frequency (%) | |
| True | 53330 | 27.7% | |
| False | 12917 | 6.7% | |
| None | 63 | < 0.1% | |
| (Missing) | 126299 | 65.6% |
| Max length | 5 |
|---|---|
| Mean length | 3.411335919 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
attributes.GoodForMeal
Categorical
| Distinct count | 77 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 84.5% |
| Missing (n) | 162683 |
| {'dessert': False, 'latenight': False, 'lunch': False, 'dinner': False, 'brunch': False, 'breakfast': False} | 8405 |
|---|---|
| {'dessert': False, 'latenight': False, 'lunch': True, 'dinner': True, 'brunch': False, 'breakfast': False} | 7711 |
| {'dessert': False, 'latenight': False, 'lunch': True, 'dinner': False, 'brunch': False, 'breakfast': False} | 3203 |
| Other values (73) | 10607 |
| (Missing) |
| Value | Count | Frequency (%) | |
| {'dessert': False, 'latenight': False, 'lunch': False, 'dinner': False, 'brunch': False, 'breakfast': False} | 8405 | 4.4% | |
| {'dessert': False, 'latenight': False, 'lunch': True, 'dinner': True, 'brunch': False, 'breakfast': False} | 7711 | 4.0% | |
| {'dessert': False, 'latenight': False, 'lunch': True, 'dinner': False, 'brunch': False, 'breakfast': False} | 3203 | 1.7% | |
| {'dessert': False, 'latenight': False, 'lunch': False, 'dinner': True, 'brunch': False, 'breakfast': False} | 2545 | 1.3% | |
| {'dessert': False, 'latenight': False, 'lunch': True, 'dinner': False, 'brunch': True, 'breakfast': True} | 1009 | 0.5% | |
| {'dessert': False, 'latenight': True, 'lunch': True, 'dinner': True, 'brunch': False, 'breakfast': False} | 744 | 0.4% | |
| {'dessert': True, 'latenight': False, 'lunch': True, 'dinner': True, 'brunch': False, 'breakfast': False} | 635 | 0.3% | |
| {'dessert': False, 'latenight': False, 'lunch': False, 'dinner': False, 'brunch': False, 'breakfast': True} | 460 | 0.2% | |
| {'dessert': False, 'latenight': False, 'lunch': True, 'dinner': True, 'brunch': True, 'breakfast': False} | 436 | 0.2% | |
| {'dessert': False, 'latenight': False, 'lunch': True, 'dinner': False, 'brunch': True, 'breakfast': False} | 397 | 0.2% | |
| Other values (66) | 4381 | 2.3% | |
| (Missing) | 162683 | 84.5% |
| Max length | 108 |
|---|---|
| Mean length | 18.98549912 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
attributes.HairSpecializesIn
Categorical
| Distinct count | 129 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 99.5% |
| Missing (n) | 191603 |
| {'straightperms': False, 'coloring': False, 'extensions': False, 'africanamerican': False, 'curly': False, 'kids': False, 'perms': False, 'asian': False} | 135 |
|---|---|
| {'straightperms': True, 'coloring': True, 'extensions': True, 'africanamerican': True, 'curly': True, 'kids': True, 'perms': True, 'asian': True} | 113 |
| {'straightperms': False, 'coloring': True, 'extensions': False, 'africanamerican': False, 'curly': False, 'kids': False, 'perms': False, 'asian': False} | 44 |
| Other values (125) | 714 |
| (Missing) |
| Value | Count | Frequency (%) | |
| {'straightperms': False, 'coloring': False, 'extensions': False, 'africanamerican': False, 'curly': False, 'kids': False, 'perms': False, 'asian': False} | 135 | 0.1% | |
| {'straightperms': True, 'coloring': True, 'extensions': True, 'africanamerican': True, 'curly': True, 'kids': True, 'perms': True, 'asian': True} | 113 | 0.1% | |
| {'straightperms': False, 'coloring': True, 'extensions': False, 'africanamerican': False, 'curly': False, 'kids': False, 'perms': False, 'asian': False} | 44 | < 0.1% | |
| {'straightperms': False, 'coloring': True, 'extensions': True, 'africanamerican': False, 'curly': False, 'kids': False, 'perms': False, 'asian': False} | 39 | < 0.1% | |
| None | 31 | < 0.1% | |
| {'perms': True, 'coloring': True, 'extensions': True, 'curly': True, 'kids': True} | 30 | < 0.1% | |
| {'straightperms': True, 'coloring': True, 'extensions': True, 'africanamerican': False, 'curly': True, 'kids': True, 'perms': True, 'asian': True} | 26 | < 0.1% | |
| {'perms': False, 'coloring': False, 'extensions': False, 'curly': False, 'kids': False} | 26 | < 0.1% | |
| {'straightperms': False, 'coloring': True, 'extensions': True, 'africanamerican': False, 'curly': True, 'kids': False, 'perms': False, 'asian': False} | 24 | < 0.1% | |
| {'straightperms': False, 'coloring': True, 'extensions': False, 'africanamerican': False, 'curly': True, 'kids': False, 'perms': False, 'asian': False} | 22 | < 0.1% | |
| Other values (118) | 516 | 0.3% | |
| (Missing) | 191603 | 99.5% |
| Max length | 153 |
|---|---|
| Mean length | 3.690642701 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
attributes.HappyHour
Unsupported
This variable is an unsupported type, check if it needs cleaning or further analysis
| Unsupported value |
|---|
attributes.HasTV
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 75.0% |
| Missing (n) | 144511 |
| True | 25596 |
|---|---|
| False | 22448 |
| None | 54 |
| (Missing) |
| Value | Count | Frequency (%) | |
| True | 25596 | 13.3% | |
| False | 22448 | 11.7% | |
| None | 54 | < 0.1% | |
| (Missing) | 144511 | 75.0% |
| Max length | 5 |
|---|---|
| Mean length | 3.366265335 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
attributes.Music
Categorical
| Distinct count | 87 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 97.3% |
| Missing (n) | 187360 |
| {'dj': False, 'background_music': False, 'no_music': False, 'jukebox': False, 'live': False, 'video': False, 'karaoke': False} | 2230 |
|---|---|
| {'dj': False, 'background_music': True, 'no_music': False, 'jukebox': False, 'live': False, 'video': False, 'karaoke': False} | 524 |
| {'dj': False, 'background_music': False, 'no_music': False, 'jukebox': False, 'live': True, 'video': False, 'karaoke': False} | 495 |
| Other values (83) | 2000 |
| (Missing) |
| Value | Count | Frequency (%) | |
| {'dj': False, 'background_music': False, 'no_music': False, 'jukebox': False, 'live': False, 'video': False, 'karaoke': False} | 2230 | 1.2% | |
| {'dj': False, 'background_music': True, 'no_music': False, 'jukebox': False, 'live': False, 'video': False, 'karaoke': False} | 524 | 0.3% | |
| {'dj': False, 'background_music': False, 'no_music': False, 'jukebox': False, 'live': True, 'video': False, 'karaoke': False} | 495 | 0.3% | |
| {'dj': False} | 397 | 0.2% | |
| {'dj': False, 'background_music': True, 'jukebox': False, 'live': False, 'video': False, 'karaoke': False} | 256 | 0.1% | |
| {'dj': True, 'background_music': False, 'no_music': False, 'jukebox': False, 'live': False, 'video': False, 'karaoke': False} | 244 | 0.1% | |
| {'dj': False, 'background_music': False, 'no_music': False, 'jukebox': True, 'live': False, 'video': False, 'karaoke': False} | 234 | 0.1% | |
| {} | 125 | 0.1% | |
| {'dj': True} | 110 | 0.1% | |
| None | 68 | < 0.1% | |
| Other values (76) | 566 | 0.3% | |
| (Missing) | 187360 | 97.3% |
| Max length | 126 |
|---|---|
| Mean length | 5.826056934 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
attributes.NoiseLevel
Categorical
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 77.2% |
| Missing (n) | 148730 |
| u'average' | 22681 |
|---|---|
| u'quiet' | 8080 |
| 'average' | 5620 |
| Other values (6) | 7498 |
| (Missing) |
| Value | Count | Frequency (%) | |
| u'average' | 22681 | 11.8% | |
| u'quiet' | 8080 | 4.2% | |
| 'average' | 5620 | 2.9% | |
| u'loud' | 3509 | 1.8% | |
| u'very_loud' | 1614 | 0.8% | |
| 'quiet' | 1568 | 0.8% | |
| 'loud' | 574 | 0.3% | |
| 'very_loud' | 160 | 0.1% | |
| None | 73 | < 0.1% | |
| (Missing) | 148730 | 77.2% |
| Max length | 12 |
|---|---|
| Mean length | 4.405936379 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | True |
attributes.Open24Hours
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | > 99.9% |
| Missing (n) | 192596 |
| False | 9 |
|---|---|
| True | 4 |
| (Missing) |
| Value | Count | Frequency (%) | |
| False | 9 | < 0.1% | |
| True | 4 | < 0.1% | |
| (Missing) | 192596 | > 99.9% |
attributes.OutdoorSeating
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 71.5% |
| Missing (n) | 137786 |
| False | |
|---|---|
| True | 21942 |
| None | 68 |
| (Missing) |
| Value | Count | Frequency (%) | |
| False | 32813 | 17.0% | |
| True | 21942 | 11.4% | |
| None | 68 | < 0.1% | |
| (Missing) | 137786 | 71.5% |
| Max length | 5 |
|---|---|
| Mean length | 3.454994315 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
attributes.RestaurantsAttire
Categorical
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 74.7% |
| Missing (n) | 143970 |
| u'casual' | 28320 |
|---|---|
| 'casual' | 18753 |
| u'dressy' | 962 |
| Other values (4) | 604 |
| (Missing) |
| Value | Count | Frequency (%) | |
| u'casual' | 28320 | 14.7% | |
| 'casual' | 18753 | 9.7% | |
| u'dressy' | 962 | 0.5% | |
| 'dressy' | 427 | 0.2% | |
| u'formal' | 74 | < 0.1% | |
| 'formal' | 55 | < 0.1% | |
| None | 48 | < 0.1% | |
| (Missing) | 143970 | 74.7% |
| Max length | 9 |
|---|---|
| Mean length | 4.414051264 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | True |
attributes.RestaurantsCounterService
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | > 99.9% |
| Missing (n) | 192598 |
| True | 8 |
|---|---|
| False | 3 |
| (Missing) |
| Value | Count | Frequency (%) | |
| True | 8 | < 0.1% | |
| False | 3 | < 0.1% | |
| (Missing) | 192598 | > 99.9% |
attributes.RestaurantsDelivery
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 72.7% |
| Missing (n) | 140087 |
| False | |
|---|---|
| True | 13895 |
| None | 68 |
| (Missing) |
| Value | Count | Frequency (%) | |
| False | 38559 | 20.0% | |
| True | 13895 | 7.2% | |
| None | 68 | < 0.1% | |
| (Missing) | 140087 | 72.7% |
| Max length | 5 |
|---|---|
| Mean length | 3.472880291 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
attributes.RestaurantsGoodForGroups
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 71.6% |
| Missing (n) | 137891 |
| True | |
|---|---|
| False | 7254 |
| None | 42 |
| (Missing) |
| Value | Count | Frequency (%) | |
| True | 47422 | 24.6% | |
| False | 7254 | 3.8% | |
| None | 42 | < 0.1% | |
| (Missing) | 137891 | 71.6% |
| Max length | 5 |
|---|---|
| Mean length | 3.321750282 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
attributes.RestaurantsPriceRange2
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 43.8% |
| Missing (n) | 84430 |
| 2 | |
|---|---|
| 1 | |
| 3 | 10462 |
| Other values (2) | 2352 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 2 | 61506 | 31.9% | |
| 1 | 33859 | 17.6% | |
| 3 | 10462 | 5.4% | |
| 4 | 2255 | 1.2% | |
| None | 97 | 0.1% | |
| (Missing) | 84430 | 43.8% |
| Max length | 4 |
|---|---|
| Mean length | 1.878209222 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
attributes.RestaurantsReservations
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 72.9% |
| Missing (n) | 140322 |
| False | |
|---|---|
| True | 20147 |
| None | 49 |
| (Missing) |
| Value | Count | Frequency (%) | |
| False | 32091 | 16.7% | |
| True | 20147 | 10.5% | |
| None | 49 | < 0.1% | |
| (Missing) | 140322 | 72.9% |
| Max length | 5 |
|---|---|
| Mean length | 3.438079217 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
attributes.RestaurantsTableService
Unsupported
This variable is an unsupported type, check if it needs cleaning or further analysis
| Unsupported value |
|---|
attributes.RestaurantsTakeOut
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 67.8% |
| Missing (n) | 130532 |
| True | |
|---|---|
| False | 5520 |
| None | 69 |
| (Missing) |
| Value | Count | Frequency (%) | |
| True | 56488 | 29.3% | |
| False | 5520 | 2.9% | |
| None | 69 | < 0.1% | |
| (Missing) | 130532 | 67.8% |
| Max length | 5 |
|---|---|
| Mean length | 3.350954524 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
attributes.Smoking
Categorical
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 98.2% |
| Missing (n) | 189111 |
| u'no' | 1767 |
|---|---|
| u'outdoor' | 1273 |
| u'yes' | 350 |
| Other values (4) | 108 |
| (Missing) |
| Value | Count | Frequency (%) | |
| u'no' | 1767 | 0.9% | |
| u'outdoor' | 1273 | 0.7% | |
| u'yes' | 350 | 0.2% | |
| 'no' | 61 | < 0.1% | |
| 'outdoor' | 23 | < 0.1% | |
| None | 21 | < 0.1% | |
| 'yes' | 3 | < 0.1% | |
| (Missing) | 189111 | 98.2% |
| Max length | 10 |
|---|---|
| Mean length | 3.071237585 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | True |
attributes.WheelchairAccessible
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 89.6% |
| Missing (n) | 172650 |
| True | 17190 |
|---|---|
| False | 2723 |
| None | 46 |
| (Missing) |
| Value | Count | Frequency (%) | |
| True | 17190 | 8.9% | |
| False | 2723 | 1.4% | |
| None | 46 | < 0.1% | |
| (Missing) | 172650 | 89.6% |
| Max length | 5 |
|---|---|
| Mean length | 3.117761891 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
attributes.WiFi
Categorical
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 74.0% |
| Missing (n) | 142545 |
| u'free' | 16355 |
|---|---|
| u'no' | 14896 |
| 'free' | 9239 |
| Other values (4) | 9574 |
| (Missing) |
| Value | Count | Frequency (%) | |
| u'free' | 16355 | 8.5% | |
| u'no' | 14896 | 7.7% | |
| 'free' | 9239 | 4.8% | |
| 'no' | 8864 | 4.6% | |
| u'paid' | 414 | 0.2% | |
| 'paid' | 170 | 0.1% | |
| None | 126 | 0.1% | |
| (Missing) | 142545 | 74.0% |
| Max length | 7 |
|---|---|
| Mean length | 3.69615127 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | True |
business_id
Categorical, Unique
| First 5 values |
|---|
| --1UhMGODdWsrMastO9DZw |
| --6MefnULPED_I942VcFNA |
| --7zmmkVg-IMGaXbuVd0SQ |
| --8LPVSo5i0Oo61X01sV9A |
| --9QQLMTbFzLJ_oT-ON3Xw |
| Last 5 values |
|---|
| zzvlwkcNR1CCqOPXwuvz2A |
| zzwaS0xn1MVEPEf0hNLjew |
| zzwhN7x37nyjP0ZM8oiHmw |
| zzwicjPC9g246MK2M1ZFBA |
| zzzaIBwimxVej4tY6qFOUQ |
First 5 values
| Value | Count | Frequency (%) | |
| --1UhMGODdWsrMastO9DZw | 1 | < 0.1% | |
| --6MefnULPED_I942VcFNA | 1 | < 0.1% | |
| --7zmmkVg-IMGaXbuVd0SQ | 1 | < 0.1% | |
| --8LPVSo5i0Oo61X01sV9A | 1 | < 0.1% | |
| --9QQLMTbFzLJ_oT-ON3Xw | 1 | < 0.1% |
Last 5 values
| Value | Count | Frequency (%) | |
| zzzaIBwimxVej4tY6qFOUQ | 1 | < 0.1% | |
| zzwicjPC9g246MK2M1ZFBA | 1 | < 0.1% | |
| zzwhN7x37nyjP0ZM8oiHmw | 1 | < 0.1% | |
| zzwaS0xn1MVEPEf0hNLjew | 1 | < 0.1% | |
| zzvlwkcNR1CCqOPXwuvz2A | 1 | < 0.1% |
categories
Categorical
| Distinct count | 93386 |
|---|---|
| Unique (%) | 48.5% |
| Missing (%) | 0.3% |
| Missing (n) | 482 |
| Restaurants, Pizza | 1042 |
|---|---|
| Nail Salons, Beauty & Spas | 1031 |
| Pizza, Restaurants | 993 |
| Other values (93382) |
| Value | Count | Frequency (%) | |
| Restaurants, Pizza | 1042 | 0.5% | |
| Nail Salons, Beauty & Spas | 1031 | 0.5% | |
| Pizza, Restaurants | 993 | 0.5% | |
| Beauty & Spas, Nail Salons | 947 | 0.5% | |
| Food, Coffee & Tea | 888 | 0.5% | |
| Mexican, Restaurants | 885 | 0.5% | |
| Coffee & Tea, Food | 865 | 0.4% | |
| Restaurants, Mexican | 853 | 0.4% | |
| Chinese, Restaurants | 840 | 0.4% | |
| Hair Salons, Beauty & Spas | 831 | 0.4% | |
| Other values (93375) | 182952 | 95.0% |
| Max length | 550 |
|---|---|
| Mean length | 55.02609432 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
city
Categorical
| Distinct count | 1204 |
|---|---|
| Unique (%) | 0.6% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| Las Vegas | |
|---|---|
| Toronto | 18906 |
| Phoenix | 18766 |
| Other values (1200) |
| Value | Count | Frequency (%) | |
| Las Vegas | 29370 | 15.2% | |
| Toronto | 18906 | 9.8% | |
| Phoenix | 18766 | 9.7% | |
| Charlotte | 9509 | 4.9% | |
| Scottsdale | 8837 | 4.6% | |
| Calgary | 7736 | 4.0% | |
| Pittsburgh | 7017 | 3.6% | |
| Montréal | 6449 | 3.3% | |
| Mesa | 6080 | 3.2% | |
| Henderson | 4892 | 2.5% | |
| Other values (1193) | 75046 | 39.0% |
| Max length | 50 |
|---|---|
| Mean length | 8.309699962 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
hours
Categorical
| Distinct count | 51567 |
|---|---|
| Unique (%) | 26.8% |
| Missing (%) | 23.3% |
| Missing (n) | 44830 |
| {'Monday': '0:0-0:0', 'Tuesday': '0:0-0:0', 'Wednesday': '0:0-0:0', 'Thursday': '0:0-0:0', 'Friday': '0:0-0:0', 'Saturday': '0:0-0:0', 'Sunday': '0:0-0:0'} | 7818 |
|---|---|
| {'Monday': '8:0-17:0', 'Tuesday': '8:0-17:0', 'Wednesday': '8:0-17:0', 'Thursday': '8:0-17:0', 'Friday': '8:0-17:0'} | 3006 |
| {'Monday': '9:0-17:0', 'Tuesday': '9:0-17:0', 'Wednesday': '9:0-17:0', 'Thursday': '9:0-17:0', 'Friday': '9:0-17:0'} | 2608 |
| Other values (51563) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| {'Monday': '0:0-0:0', 'Tuesday': '0:0-0:0', 'Wednesday': '0:0-0:0', 'Thursday': '0:0-0:0', 'Friday': '0:0-0:0', 'Saturday': '0:0-0:0', 'Sunday': '0:0-0:0'} | 7818 | 4.1% | |
| {'Monday': '8:0-17:0', 'Tuesday': '8:0-17:0', 'Wednesday': '8:0-17:0', 'Thursday': '8:0-17:0', 'Friday': '8:0-17:0'} | 3006 | 1.6% | |
| {'Monday': '9:0-17:0', 'Tuesday': '9:0-17:0', 'Wednesday': '9:0-17:0', 'Thursday': '9:0-17:0', 'Friday': '9:0-17:0'} | 2608 | 1.4% | |
| {'Monday': '10:0-21:0', 'Tuesday': '10:0-21:0', 'Wednesday': '10:0-21:0', 'Thursday': '10:0-21:0', 'Friday': '10:0-21:0', 'Saturday': '10:0-21:0', 'Sunday': '11:0-18:0'} | 985 | 0.5% | |
| {'Monday': '11:0-22:0', 'Tuesday': '11:0-22:0', 'Wednesday': '11:0-22:0', 'Thursday': '11:0-22:0', 'Friday': '11:0-22:0', 'Saturday': '11:0-22:0', 'Sunday': '11:0-22:0'} | 892 | 0.5% | |
| {'Monday': '11:0-22:0', 'Tuesday': '11:0-22:0', 'Wednesday': '11:0-22:0', 'Thursday': '11:0-22:0', 'Friday': '11:0-23:0', 'Saturday': '11:0-23:0', 'Sunday': '11:0-22:0'} | 816 | 0.4% | |
| {'Monday': '8:30-17:0', 'Tuesday': '8:30-17:0', 'Wednesday': '8:30-17:0', 'Thursday': '8:30-17:0', 'Friday': '8:30-17:0'} | 568 | 0.3% | |
| {'Monday': '11:0-21:0', 'Tuesday': '11:0-21:0', 'Wednesday': '11:0-21:0', 'Thursday': '11:0-21:0', 'Friday': '11:0-21:0', 'Saturday': '11:0-21:0', 'Sunday': '11:0-21:0'} | 554 | 0.3% | |
| {'Monday': '9:0-17:0', 'Tuesday': '9:0-17:0', 'Wednesday': '9:0-17:0', 'Thursday': '9:0-17:0', 'Friday': '9:0-17:0', 'Saturday': '9:0-17:0'} | 539 | 0.3% | |
| {'Monday': '10:0-22:0', 'Tuesday': '10:0-22:0', 'Wednesday': '10:0-22:0', 'Thursday': '10:0-22:0', 'Friday': '10:0-22:0', 'Saturday': '10:0-22:0', 'Sunday': '10:0-22:0'} | 523 | 0.3% | |
| Other values (51556) | 129470 | 67.2% | |
| (Missing) | 44830 | 23.3% |
| Max length | 183 |
|---|---|
| Mean length | 115.4857613 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
hours.Friday
Categorical
| Distinct count | 1565 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 24.6% |
| Missing (n) | 47435 |
| 0:0-0:0 | 8098 |
|---|---|
| 9:0-17:0 | 6584 |
| 8:0-17:0 | 6124 |
| Other values (1561) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| 0:0-0:0 | 8098 | 4.2% | |
| 9:0-17:0 | 6584 | 3.4% | |
| 8:0-17:0 | 6124 | 3.2% | |
| 9:0-18:0 | 5866 | 3.0% | |
| 10:0-21:0 | 4635 | 2.4% | |
| 11:0-22:0 | 3868 | 2.0% | |
| 10:0-18:0 | 3802 | 2.0% | |
| 11:0-23:0 | 3412 | 1.8% | |
| 10:0-19:0 | 3225 | 1.7% | |
| 8:0-18:0 | 3212 | 1.7% | |
| Other values (1554) | 96348 | 50.0% | |
| (Missing) | 47435 | 24.6% |
| Max length | 11 |
|---|---|
| Mean length | 7.147770873 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
hours.Monday
Categorical
| Distinct count | 1399 |
|---|---|
| Unique (%) | 0.7% |
| Missing (%) | 29.5% |
| Missing (n) | 56842 |
| 0:0-0:0 | |
|---|---|
| 8:0-17:0 | 5969 |
| 9:0-17:0 | 5881 |
| Other values (1395) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| 0:0-0:0 | 20865 | 10.8% | |
| 8:0-17:0 | 5969 | 3.1% | |
| 9:0-17:0 | 5881 | 3.1% | |
| 9:0-18:0 | 4594 | 2.4% | |
| 11:0-22:0 | 4274 | 2.2% | |
| 10:0-21:0 | 4202 | 2.2% | |
| 9:0-21:0 | 3115 | 1.6% | |
| 11:0-21:0 | 3014 | 1.6% | |
| 10:0-18:0 | 2975 | 1.5% | |
| 8:0-18:0 | 2766 | 1.4% | |
| Other values (1388) | 78112 | 40.6% | |
| (Missing) | 56842 | 29.5% |
| Max length | 11 |
|---|---|
| Mean length | 6.77708726 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
hours.Saturday
Categorical
| Distinct count | 1506 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 34.7% |
| Missing (n) | 66748 |
| 0:0-0:0 | 8128 |
|---|---|
| 9:0-17:0 | 4774 |
| 9:0-18:0 | 4257 |
| Other values (1502) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| 0:0-0:0 | 8128 | 4.2% | |
| 9:0-17:0 | 4774 | 2.5% | |
| 9:0-18:0 | 4257 | 2.2% | |
| 10:0-18:0 | 3869 | 2.0% | |
| 10:0-17:0 | 3573 | 1.9% | |
| 10:0-21:0 | 3364 | 1.7% | |
| 11:0-22:0 | 3341 | 1.7% | |
| 11:0-23:0 | 2961 | 1.5% | |
| 8:0-17:0 | 2305 | 1.2% | |
| 9:0-21:0 | 2284 | 1.2% | |
| Other values (1495) | 87005 | 45.2% | |
| (Missing) | 66748 | 34.7% |
| Max length | 11 |
|---|---|
| Mean length | 6.579879445 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
hours.Sunday
Categorical
| Distinct count | 1365 |
|---|---|
| Unique (%) | 0.7% |
| Missing (%) | 52.6% |
| Missing (n) | 101273 |
| 0:0-0:0 | 7989 |
|---|---|
| 11:0-18:0 | 3252 |
| 11:0-22:0 | 3110 |
| Other values (1361) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| 0:0-0:0 | 7989 | 4.1% | |
| 11:0-18:0 | 3252 | 1.7% | |
| 11:0-22:0 | 3110 | 1.6% | |
| 10:0-17:0 | 2710 | 1.4% | |
| 10:0-18:0 | 2705 | 1.4% | |
| 12:0-17:0 | 2486 | 1.3% | |
| 11:0-17:0 | 2388 | 1.2% | |
| 11:0-21:0 | 2379 | 1.2% | |
| 9:0-17:0 | 1915 | 1.0% | |
| 12:0-18:0 | 1748 | 0.9% | |
| Other values (1354) | 60654 | 31.5% | |
| (Missing) | 101273 | 52.6% |
| Max length | 11 |
|---|---|
| Mean length | 5.645063315 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
hours.Thursday
Categorical
| Distinct count | 1525 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 24.2% |
| Missing (n) | 46706 |
| 0:0-0:0 | 8086 |
|---|---|
| 8:0-17:0 | 6689 |
| 9:0-17:0 | 6407 |
| Other values (1521) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| 0:0-0:0 | 8086 | 4.2% | |
| 8:0-17:0 | 6689 | 3.5% | |
| 9:0-17:0 | 6407 | 3.3% | |
| 9:0-18:0 | 5053 | 2.6% | |
| 10:0-21:0 | 4973 | 2.6% | |
| 11:0-22:0 | 4868 | 2.5% | |
| 11:0-21:0 | 3843 | 2.0% | |
| 10:0-20:0 | 3786 | 2.0% | |
| 9:0-21:0 | 3702 | 1.9% | |
| 10:0-19:0 | 3646 | 1.9% | |
| Other values (1514) | 94850 | 49.2% | |
| (Missing) | 46706 | 24.2% |
| Max length | 11 |
|---|---|
| Mean length | 7.195707366 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
hours.Tuesday
Categorical
| Distinct count | 1445 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 25.5% |
| Missing (n) | 49181 |
| 0:0-0:0 | 8078 |
|---|---|
| 8:0-17:0 | 6739 |
| 9:0-17:0 | 6520 |
| Other values (1441) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| 0:0-0:0 | 8078 | 4.2% | |
| 8:0-17:0 | 6739 | 3.5% | |
| 9:0-17:0 | 6520 | 3.4% | |
| 9:0-18:0 | 5377 | 2.8% | |
| 11:0-22:0 | 4884 | 2.5% | |
| 10:0-21:0 | 4587 | 2.4% | |
| 10:0-18:0 | 4020 | 2.1% | |
| 11:0-21:0 | 3766 | 2.0% | |
| 10:0-19:0 | 3606 | 1.9% | |
| 9:0-21:0 | 3478 | 1.8% | |
| Other values (1434) | 92373 | 48.0% | |
| (Missing) | 49181 | 25.5% |
| Max length | 11 |
|---|---|
| Mean length | 7.123265268 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
hours.Wednesday
Categorical
| Distinct count | 1461 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 24.6% |
| Missing (n) | 47452 |
| 0:0-0:0 | 8075 |
|---|---|
| 8:0-17:0 | 6727 |
| 9:0-17:0 | 6521 |
| Other values (1457) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| 0:0-0:0 | 8075 | 4.2% | |
| 8:0-17:0 | 6727 | 3.5% | |
| 9:0-17:0 | 6521 | 3.4% | |
| 9:0-18:0 | 5491 | 2.9% | |
| 11:0-22:0 | 4965 | 2.6% | |
| 10:0-21:0 | 4660 | 2.4% | |
| 10:0-18:0 | 4045 | 2.1% | |
| 11:0-21:0 | 3823 | 2.0% | |
| 10:0-19:0 | 3512 | 1.8% | |
| 9:0-21:0 | 3422 | 1.8% | |
| Other values (1450) | 93916 | 48.8% | |
| (Missing) | 47452 | 24.6% |
| Max length | 11 |
|---|---|
| Mean length | 7.176076923 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
is_open
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 158525 | 82.3% | |
| 0 | 34084 | 17.7% |
latitude
Numeric
| Distinct count | 155162 |
|---|---|
| Unique (%) | 80.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 38.54180263 |
|---|---|
| Minimum | 33.204642 |
| Maximum | 51.29994269 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 33.204642 |
|---|---|
| 5-th percentile | 33.3649772 |
| Q1 | 33.637408 |
| Median | 36.144815 |
| Q3 | 43.602989 |
| 95-th percentile | 45.5364432 |
| Maximum | 51.29994269 |
| Range | 18.09530069 |
| Interquartile range | 9.965581 |
Descriptive statistics
| Standard deviation | 4.941963503 |
|---|---|
| Coef of variation | 0.1282234656 |
| Kurtosis | -0.5181507852 |
| Mean | 38.54180263 |
| MAD | 4.43654809 |
| Skewness | 0.6841439291 |
| Sum | 7423498.063 |
| Variance | 24.42300326 |
| Memory size | 1.5 MiB |
| Value | Count | Frequency (%) | |
| 36.1697096 | 167 | 0.1% | |
| 36.128561 | 125 | 0.1% | |
| 33.4483771 | 116 | 0.1% | |
| 36.175 | 91 | < 0.1% | |
| 33.4986286 | 90 | < 0.1% | |
| 43.653226 | 88 | < 0.1% | |
| 36.18 | 72 | < 0.1% | |
| 33.3260297 | 69 | < 0.1% | |
| 33.4499672 | 67 | < 0.1% | |
| 36.0357492 | 65 | < 0.1% | |
| Other values (155152) | 191659 | 99.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 33.204642 | 1 | < 0.1% | |
| 33.20486311 | 1 | < 0.1% | |
| 33.20530832 | 1 | < 0.1% | |
| 33.2057187 | 2 | < 0.1% | |
| 33.205767 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 51.29994269 | 1 | < 0.1% | |
| 51.2978143 | 1 | < 0.1% | |
| 51.2966203 | 1 | < 0.1% | |
| 51.2965919 | 1 | < 0.1% | |
| 51.2963563 | 1 | < 0.1% |
longitude
Numeric
| Distinct count | 150404 |
|---|---|
| Unique (%) | 78.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | -97.59478532 |
|---|---|
| Minimum | -115.4934712 |
| Maximum | -72.9119819 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | -115.4934712 |
|---|---|
| 5-th percentile | -115.2352134 |
| Q1 | -112.2746773 |
| Median | -111.7593235 |
| Q3 | -79.9836143 |
| 95-th percentile | -79.02056666 |
| Maximum | -72.9119819 |
| Range | 42.58148934 |
| Interquartile range | 32.291063 |
Descriptive statistics
| Standard deviation | 16.69772482 |
|---|---|
| Coef of variation | -0.1710923874 |
| Kurtosis | -1.896632781 |
| Mean | -97.59478532 |
| MAD | 16.48162302 |
| Skewness | 0.1398988358 |
| Sum | -18797634 |
| Variance | 278.814014 |
| Memory size | 1.5 MiB |
| Value | Count | Frequency (%) | |
| -115.1236952 | 168 | 0.1% | |
| -111.9403254 | 167 | 0.1% | |
| -115.1711298 | 158 | 0.1% | |
| -111.8210866 | 157 | 0.1% | |
| -115.2244853 | 156 | 0.1% | |
| -115.1533426 | 118 | 0.1% | |
| -112.0740373 | 116 | 0.1% | |
| -115.2659777 | 113 | 0.1% | |
| -115.2778317 | 103 | 0.1% | |
| -112.0118669 | 93 | < 0.1% | |
| Other values (150394) | 191260 | 99.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -115.4934712 | 1 | < 0.1% | |
| -115.4775186 | 1 | < 0.1% | |
| -115.47369 | 1 | < 0.1% | |
| -115.4562899 | 1 | < 0.1% | |
| -115.4548073 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| -72.9119819 | 1 | < 0.1% | |
| -72.9342959 | 1 | < 0.1% | |
| -72.94493768 | 1 | < 0.1% | |
| -72.94505 | 1 | < 0.1% | |
| -72.9453515 | 1 | < 0.1% |
name
Categorical
| Distinct count | 145046 |
|---|---|
| Unique (%) | 75.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Starbucks | 1066 |
|---|---|
| McDonald's | 806 |
| Subway | 768 |
| Other values (145043) |
| Value | Count | Frequency (%) | |
| Starbucks | 1066 | 0.6% | |
| McDonald's | 806 | 0.4% | |
| Subway | 768 | 0.4% | |
| Tim Hortons | 333 | 0.2% | |
| Pizza Hut | 320 | 0.2% | |
| Taco Bell | 313 | 0.2% | |
| Burger King | 302 | 0.2% | |
| Walgreens | 301 | 0.2% | |
| Wendy's | 294 | 0.2% | |
| The UPS Store | 279 | 0.1% | |
| Other values (145036) | 187827 | 97.5% |
| Max length | 64 |
|---|---|
| Mean length | 18.72079186 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
postal_code
Categorical
| Distinct count | 17541 |
|---|---|
| Unique (%) | 9.1% |
| Missing (%) | 0.3% |
| Missing (n) | 659 |
| 89109 | 3195 |
|---|---|
| 85251 | 2150 |
| 85260 | 1893 |
| Other values (17537) |
| Value | Count | Frequency (%) | |
| 89109 | 3195 | 1.7% | |
| 85251 | 2150 | 1.1% | |
| 85260 | 1893 | 1.0% | |
| 85281 | 1891 | 1.0% | |
| 89119 | 1866 | 1.0% | |
| 89102 | 1650 | 0.9% | |
| 85308 | 1503 | 0.8% | |
| 89103 | 1481 | 0.8% | |
| 85032 | 1435 | 0.7% | |
| 85016 | 1430 | 0.7% | |
| Other values (17530) | 173456 | 90.1% |
| Max length | 8 |
|---|---|
| Mean length | 5.478549808 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
review_count
Numeric
| Distinct count | 1184 |
|---|---|
| Unique (%) | 0.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 33.53896235 |
|---|---|
| Minimum | 3 |
| Maximum | 8348 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 4 |
| Median | 9 |
| Q3 | 25 |
| 95-th percentile | 130 |
| Maximum | 8348 |
| Range | 8345 |
| Interquartile range | 21 |
Descriptive statistics
| Standard deviation | 110.1352244 |
|---|---|
| Coef of variation | 3.2837994 |
| Kurtosis | 778.5035282 |
| Mean | 33.53896235 |
| MAD | 38.55879699 |
| Skewness | 19.60408148 |
| Sum | 6459906 |
| Variance | 12129.76766 |
| Memory size | 1.5 MiB |
| Value | Count | Frequency (%) | |
| 3 | 33940 | 17.6% | |
| 4 | 18534 | 9.6% | |
| 5 | 13615 | 7.1% | |
| 6 | 10951 | 5.7% | |
| 7 | 8911 | 4.6% | |
| 8 | 7517 | 3.9% | |
| 9 | 6548 | 3.4% | |
| 10 | 5436 | 2.8% | |
| 11 | 4783 | 2.5% | |
| 12 | 4261 | 2.2% | |
| Other values (1174) | 78113 | 40.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 3 | 33940 | 17.6% | |
| 4 | 18534 | 9.6% | |
| 5 | 13615 | 7.1% | |
| 6 | 10951 | 5.7% | |
| 7 | 8911 | 4.6% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 8348 | 1 | < 0.1% | |
| 8339 | 1 | < 0.1% | |
| 6708 | 1 | < 0.1% | |
| 5763 | 1 | < 0.1% | |
| 5484 | 1 | < 0.1% |
stars
Numeric
| Distinct count | 9 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3.58562684 |
|---|---|
| Minimum | 1 |
| Maximum | 5 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1.5 |
| Q1 | 3 |
| Median | 3.5 |
| Q3 | 4.5 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 4 |
| Interquartile range | 1.5 |
Descriptive statistics
| Standard deviation | 1.018458284 |
|---|---|
| Coef of variation | 0.2840391176 |
| Kurtosis | -0.3626834354 |
| Mean | 3.58562684 |
| MAD | 0.828370875 |
| Skewness | -0.4965602926 |
| Sum | 690624 |
| Variance | 1.037257276 |
| Memory size | 1.5 MiB |
| Value | Count | Frequency (%) | |
| 4 | 35969 | 18.7% | |
| 3.5 | 35008 | 18.2% | |
| 5 | 28216 | 14.6% | |
| 4.5 | 27301 | 14.2% | |
| 3 | 25996 | 13.5% | |
| 2.5 | 18843 | 9.8% | |
| 2 | 11426 | 5.9% | |
| 1.5 | 4976 | 2.6% | |
| 1 | 4874 | 2.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 4874 | 2.5% | |
| 1.5 | 4976 | 2.6% | |
| 2 | 11426 | 5.9% | |
| 2.5 | 18843 | 9.8% | |
| 3 | 25996 | 13.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 5 | 28216 | 14.6% | |
| 4.5 | 27301 | 14.2% | |
| 4 | 35969 | 18.7% | |
| 3.5 | 35008 | 18.2% | |
| 3 | 25996 | 13.5% |
state
Categorical
| Distinct count | 36 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| AZ | |
|---|---|
| NV | |
| ON | |
| Other values (33) |
| Value | Count | Frequency (%) | |
| AZ | 56686 | 29.4% | |
| NV | 36312 | 18.9% | |
| ON | 33412 | 17.3% | |
| NC | 14720 | 7.6% | |
| OH | 14697 | 7.6% | |
| PA | 11216 | 5.8% | |
| QC | 9219 | 4.8% | |
| AB | 8012 | 4.2% | |
| WI | 5154 | 2.7% | |
| IL | 1932 | 1.0% | |
| Other values (26) | 1249 | 0.6% |
| Max length | 3 |
|---|---|
| Mean length | 2.000057111 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
First rows
| address | attributes | attributes.AcceptsInsurance | attributes.AgesAllowed | attributes.Alcohol | attributes.Ambience | attributes.BestNights | attributes.BikeParking | attributes.BusinessAcceptsBitcoin | attributes.BusinessAcceptsCreditCards | attributes.BusinessParking | attributes.ByAppointmentOnly | attributes.BYOB | attributes.BYOBCorkage | attributes.Caters | attributes.CoatCheck | attributes.Corkage | attributes.DietaryRestrictions | attributes.DogsAllowed | attributes.DriveThru | attributes.GoodForDancing | attributes.GoodForKids | attributes.GoodForMeal | attributes.HairSpecializesIn | attributes.HappyHour | attributes.HasTV | attributes.Music | attributes.NoiseLevel | attributes.Open24Hours | attributes.OutdoorSeating | attributes.RestaurantsAttire | attributes.RestaurantsCounterService | attributes.RestaurantsDelivery | attributes.RestaurantsGoodForGroups | attributes.RestaurantsPriceRange2 | attributes.RestaurantsReservations | attributes.RestaurantsTableService | attributes.RestaurantsTakeOut | attributes.Smoking | attributes.WheelchairAccessible | attributes.WiFi | business_id | categories | city | hours | hours.Friday | hours.Monday | hours.Saturday | hours.Sunday | hours.Thursday | hours.Tuesday | hours.Wednesday | is_open | latitude | longitude | name | postal_code | review_count | stars | state | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2818 E Camino Acequia Drive | {'GoodForKids': 'False'} | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | False | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1SWheh84yJXfytovILXOAQ | Golf, Active Life | Phoenix | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | 33.522143 | -112.018481 | Arizona Biltmore Golf Club | 85016 | 5 | 3.0 | AZ |
| 1 | 30 Eglinton Avenue W | {'RestaurantsReservations': 'True', 'GoodForMeal': "{'dessert': False, 'latenight': False, 'lunch': True, 'dinner': True, 'brunch': False, 'breakfast': False}", 'BusinessParking': "{'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False}", 'Caters': 'True', 'NoiseLevel': "u'loud'", 'RestaurantsTableService': 'True', 'RestaurantsTakeOut': 'True', 'RestaurantsPriceRange2': '2', 'OutdoorSeating': 'False', 'BikeParking': 'False', 'Ambience': "{'romantic': False, 'intimate': False, 'classy': False, 'hipster': False, 'divey': False, 'touristy': False, 'trendy': False, 'upscale': False, 'casual': True}", 'HasTV': 'False', 'WiFi': "u'no'", 'GoodForKids': 'True', 'Alcohol': "u'full_bar'", 'RestaurantsAttire': "u'casual'", 'RestaurantsGoodForGroups': 'True', 'RestaurantsDelivery': 'False'} | NaN | NaN | u'full_bar' | {'romantic': False, 'intimate': False, 'classy': False, 'hipster': False, 'divey': False, 'touristy': False, 'trendy': False, 'upscale': False, 'casual': True} | NaN | False | NaN | NaN | {'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False} | NaN | NaN | NaN | True | NaN | NaN | NaN | NaN | NaN | NaN | True | {'dessert': False, 'latenight': False, 'lunch': True, 'dinner': True, 'brunch': False, 'breakfast': False} | NaN | NaN | False | NaN | u'loud' | NaN | False | u'casual' | NaN | False | True | 2 | True | True | True | NaN | NaN | u'no' | QXAEGFB4oINsVuTFxEYKFQ | Specialty Food, Restaurants, Dim Sum, Imported Food, Food, Chinese, Ethnic Food, Seafood | Mississauga | {'Monday': '9:0-0:0', 'Tuesday': '9:0-0:0', 'Wednesday': '9:0-0:0', 'Thursday': '9:0-0:0', 'Friday': '9:0-1:0', 'Saturday': '9:0-1:0', 'Sunday': '9:0-0:0'} | 9:0-1:0 | 9:0-0:0 | 9:0-1:0 | 9:0-0:0 | 9:0-0:0 | 9:0-0:0 | 9:0-0:0 | 1 | 43.605499 | -79.652289 | Emerald Chinese Restaurant | L5R 3E7 | 128 | 2.5 | ON |
| 2 | 10110 Johnston Rd, Ste 15 | {'GoodForKids': 'True', 'NoiseLevel': "u'average'", 'RestaurantsDelivery': 'False', 'GoodForMeal': "{'dessert': False, 'latenight': False, 'lunch': True, 'dinner': True, 'brunch': False, 'breakfast': False}", 'Alcohol': "u'beer_and_wine'", 'Caters': 'False', 'WiFi': "u'no'", 'RestaurantsTakeOut': 'True', 'BusinessAcceptsCreditCards': 'True', 'Ambience': "{'romantic': False, 'intimate': False, 'touristy': False, 'hipster': False, 'divey': False, 'classy': False, 'trendy': False, 'upscale': False, 'casual': True}", 'BusinessParking': "{'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False}", 'RestaurantsTableService': 'True', 'RestaurantsGoodForGroups': 'True', 'OutdoorSeating': 'False', 'HasTV': 'True', 'BikeParking': 'True', 'RestaurantsReservations': 'True', 'RestaurantsPriceRange2': '2', 'RestaurantsAttire': "'casual'"} | NaN | NaN | u'beer_and_wine' | {'romantic': False, 'intimate': False, 'touristy': False, 'hipster': False, 'divey': False, 'classy': False, 'trendy': False, 'upscale': False, 'casual': True} | NaN | True | NaN | True | {'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False} | NaN | NaN | NaN | False | NaN | NaN | NaN | NaN | NaN | NaN | True | {'dessert': False, 'latenight': False, 'lunch': True, 'dinner': True, 'brunch': False, 'breakfast': False} | NaN | NaN | True | NaN | u'average' | NaN | False | 'casual' | NaN | False | True | 2 | True | True | True | NaN | NaN | u'no' | gnKjwL_1w79qoiV3IC_xQQ | Sushi Bars, Restaurants, Japanese | Charlotte | {'Monday': '17:30-21:30', 'Wednesday': '17:30-21:30', 'Thursday': '17:30-21:30', 'Friday': '17:30-22:0', 'Saturday': '17:30-22:0', 'Sunday': '17:30-21:0'} | 17:30-22:0 | 17:30-21:30 | 17:30-22:0 | 17:30-21:0 | 17:30-21:30 | NaN | 17:30-21:30 | 1 | 35.092564 | -80.859132 | Musashi Japanese Restaurant | 28210 | 170 | 4.0 | NC |
| 3 | 15655 W Roosevelt St, Ste 237 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | xvX2CttrVhyG2z1dFg_0xw | Insurance, Financial Services | Goodyear | {'Monday': '8:0-17:0', 'Tuesday': '8:0-17:0', 'Wednesday': '8:0-17:0', 'Thursday': '8:0-17:0', 'Friday': '8:0-17:0'} | 8:0-17:0 | 8:0-17:0 | NaN | NaN | 8:0-17:0 | 8:0-17:0 | 8:0-17:0 | 1 | 33.455613 | -112.395596 | Farmers Insurance - Paul Lorenz | 85338 | 3 | 5.0 | AZ |
| 4 | 4209 Stuart Andrew Blvd, Ste F | {'BusinessAcceptsBitcoin': 'False', 'ByAppointmentOnly': 'True', 'BusinessAcceptsCreditCards': 'True'} | NaN | NaN | NaN | NaN | NaN | NaN | False | True | NaN | True | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | HhyxOkGAM07SRYtlQ4wMFQ | Plumbing, Shopping, Local Services, Home Services, Kitchen & Bath, Home & Garden, Water Heater Installation/Repair | Charlotte | {'Monday': '7:0-23:0', 'Tuesday': '7:0-23:0', 'Wednesday': '7:0-23:0', 'Thursday': '7:0-23:0', 'Friday': '7:0-23:0', 'Saturday': '7:0-23:0', 'Sunday': '7:0-23:0'} | 7:0-23:0 | 7:0-23:0 | 7:0-23:0 | 7:0-23:0 | 7:0-23:0 | 7:0-23:0 | 7:0-23:0 | 1 | 35.190012 | -80.887223 | Queen City Plumbing | 28217 | 4 | 4.0 | NC |
| 5 | Credit Valley Town Plaza, F2 - 6045 Creditview Rd | {'BusinessParking': "{'garage': False, 'street': False, 'validated': False, 'lot': False, 'valet': False}", 'RestaurantsPriceRange2': '2'} | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | {'garage': False, 'street': False, 'validated': False, 'lot': False, 'valet': False} | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2 | NaN | NaN | NaN | NaN | NaN | NaN | 68dUKd8_8liJ7in4aWOSEA | Shipping Centers, Couriers & Delivery Services, Local Services, Printing Services | Mississauga | {'Monday': '9:0-19:0', 'Tuesday': '9:0-20:0', 'Wednesday': '9:0-20:0', 'Thursday': '9:0-20:0', 'Friday': '9:0-19:0', 'Saturday': '10:0-16:0'} | 9:0-19:0 | 9:0-19:0 | 10:0-16:0 | NaN | 9:0-20:0 | 9:0-20:0 | 9:0-20:0 | 1 | 43.599475 | -79.711584 | The UPS Store | L5V 0B1 | 3 | 2.5 | ON |
| 6 | 20 Douglas Woods Drive Southeast | {'RestaurantsPriceRange2': '2', 'BusinessParking': "{'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False}", 'ByAppointmentOnly': 'True'} | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | {'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False} | True | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2 | NaN | NaN | NaN | NaN | NaN | NaN | 5JucpCfHZltJh5r1JabjDg | Beauty & Spas, Hair Salons | Calgary | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1 | 50.943646 | -114.001828 | Edgeworxx Studio | T2Z 1K4 | 7 | 3.5 | AB |
| 7 | 4545 E Tropicana Rd Ste 8, Tropicana | {'RestaurantsPriceRange2': '3', 'GoodForKids': 'True', 'BusinessAcceptsCreditCards': 'True', 'ByAppointmentOnly': 'False', 'BikeParking': 'False'} | NaN | NaN | NaN | NaN | NaN | False | NaN | True | NaN | False | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | True | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 3 | NaN | NaN | NaN | NaN | NaN | NaN | gbQN7vr_caG_A1ugSmGhWg | Hair Salons, Hair Stylists, Barbers, Men's Hair Salons, Cosmetics & Beauty Supply, Shopping, Beauty & Spas | Las Vegas | {'Monday': '10:0-19:0', 'Tuesday': '10:0-19:0', 'Wednesday': '10:0-19:0', 'Thursday': '10:0-19:0', 'Friday': '10:0-19:0', 'Saturday': '10:0-19:0', 'Sunday': '10:0-18:0'} | 10:0-19:0 | 10:0-19:0 | 10:0-19:0 | 10:0-18:0 | 10:0-19:0 | 10:0-19:0 | 10:0-19:0 | 1 | 36.099872 | -115.074574 | Supercuts | 89121 | 3 | 3.5 | NV |
| 8 | 5940 W Union Hills Dr | {'RestaurantsPriceRange2': '2', 'ByAppointmentOnly': 'True', 'BusinessParking': "{'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False}", 'BusinessAcceptsCreditCards': 'True', 'BikeParking': 'False'} | NaN | NaN | NaN | NaN | NaN | False | NaN | True | {'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False} | True | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2 | NaN | NaN | NaN | NaN | NaN | NaN | Y6iyemLX_oylRpnr38vgMA | Nail Salons, Beauty & Spas, Day Spas | Glendale | {'Tuesday': '12:0-18:0', 'Wednesday': '10:0-18:0', 'Thursday': '12:0-18:0', 'Friday': '10:0-17:0', 'Saturday': '10:0-14:0'} | 10:0-17:0 | NaN | 10:0-14:0 | NaN | 12:0-18:0 | 12:0-18:0 | 10:0-18:0 | 0 | 33.654815 | -112.188568 | Vita Bella Fine Day Spa | 85308 | 8 | 5.0 | AZ |
| 9 | 21689 Lorain Rd | {'ByAppointmentOnly': 'False', 'BusinessAcceptsCreditCards': 'True', 'RestaurantsPriceRange2': '2', 'BusinessParking': "{'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False}", 'AcceptsInsurance': 'False'} | False | NaN | NaN | NaN | NaN | NaN | NaN | True | {'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False} | False | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2 | NaN | NaN | NaN | NaN | NaN | NaN | 4GBVPIYRvzGh4K4TkRQ_rw | Beauty & Spas, Nail Salons, Day Spas, Massage | Fairview Park | {'Tuesday': '9:0-21:0', 'Wednesday': '9:0-21:0', 'Thursday': '9:0-21:0', 'Friday': '9:0-19:0', 'Saturday': '9:0-16:0'} | 9:0-19:0 | NaN | 9:0-16:0 | NaN | 9:0-21:0 | 9:0-21:0 | 9:0-21:0 | 1 | 41.440825 | -81.854097 | Options Salon & Spa | 44126 | 8 | 4.5 | OH |
Last rows
| address | attributes | attributes.AcceptsInsurance | attributes.AgesAllowed | attributes.Alcohol | attributes.Ambience | attributes.BestNights | attributes.BikeParking | attributes.BusinessAcceptsBitcoin | attributes.BusinessAcceptsCreditCards | attributes.BusinessParking | attributes.ByAppointmentOnly | attributes.BYOB | attributes.BYOBCorkage | attributes.Caters | attributes.CoatCheck | attributes.Corkage | attributes.DietaryRestrictions | attributes.DogsAllowed | attributes.DriveThru | attributes.GoodForDancing | attributes.GoodForKids | attributes.GoodForMeal | attributes.HairSpecializesIn | attributes.HappyHour | attributes.HasTV | attributes.Music | attributes.NoiseLevel | attributes.Open24Hours | attributes.OutdoorSeating | attributes.RestaurantsAttire | attributes.RestaurantsCounterService | attributes.RestaurantsDelivery | attributes.RestaurantsGoodForGroups | attributes.RestaurantsPriceRange2 | attributes.RestaurantsReservations | attributes.RestaurantsTableService | attributes.RestaurantsTakeOut | attributes.Smoking | attributes.WheelchairAccessible | attributes.WiFi | business_id | categories | city | hours | hours.Friday | hours.Monday | hours.Saturday | hours.Sunday | hours.Thursday | hours.Tuesday | hours.Wednesday | is_open | latitude | longitude | name | postal_code | review_count | stars | state | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 192599 | 343 N Gilbert Rd | {'BusinessAcceptsCreditCards': 'True', 'ByAppointmentOnly': 'True'} | NaN | NaN | NaN | NaN | NaN | NaN | NaN | True | NaN | True | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | ABjONdA5Fw8XBOM65tmW4w | Plumbing, Water Heater Installation/Repair, Professional Services, Home Services, Contractors | Gilbert | {'Monday': '7:0-17:0', 'Tuesday': '7:0-17:30', 'Wednesday': '7:0-17:30', 'Thursday': '7:0-17:30', 'Friday': '7:0-17:30', 'Saturday': '8:0-17:0'} | 7:0-17:30 | 7:0-17:0 | 8:0-17:0 | NaN | 7:0-17:30 | 7:0-17:30 | 7:0-17:30 | 1 | 33.356540 | -111.789367 | Phend Plumbing & Rooter | 85234 | 47 | 5.0 | AZ |
| 192600 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | ZidLd2a1uJCMfIhLylX5ww | Pet Training, Professional Services, Pet Services, Pets | Phoenix | {'Monday': '8:0-19:30', 'Tuesday': '8:0-19:30', 'Wednesday': '8:0-19:30', 'Thursday': '8:0-19:30', 'Friday': '8:0-19:30', 'Saturday': '8:0-19:30', 'Sunday': '8:0-15:0'} | 8:0-19:30 | 8:0-19:30 | 8:0-19:30 | 8:0-15:0 | 8:0-19:30 | 8:0-19:30 | 8:0-19:30 | 1 | 33.347160 | -111.975380 | Team Canine | 85076 | 19 | 4.5 | AZ |
| 192601 | 5350 E Marriott Dr | {'BusinessAcceptsBitcoin': 'False', 'GoodForKids': 'True', 'BusinessAcceptsCreditCards': 'True', 'ByAppointmentOnly': 'False', 'BusinessParking': "{'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': True}", 'WheelchairAccessible': 'True', 'RestaurantsPriceRange2': '3', 'WiFi': "u'paid'", 'DogsAllowed': 'False'} | NaN | NaN | NaN | NaN | NaN | NaN | False | True | {'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': True} | False | NaN | NaN | NaN | NaN | NaN | NaN | False | NaN | NaN | True | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 3 | NaN | NaN | NaN | NaN | True | u'paid' | jJoPLIhCjkGXy59I4Jl6zw | Golf, Hotels, Day Spas, Hotels & Travel, Event Planning & Services, Beauty & Spas, Active Life, Venues & Event Spaces, Resorts | Phoenix | {'Monday': '0:0-0:0', 'Tuesday': '0:0-0:0', 'Wednesday': '0:0-0:0', 'Thursday': '0:0-0:0', 'Friday': '0:0-0:0', 'Saturday': '0:0-0:0', 'Sunday': '0:0-0:0'} | 0:0-0:0 | 0:0-0:0 | 0:0-0:0 | 0:0-0:0 | 0:0-0:0 | 0:0-0:0 | 0:0-0:0 | 1 | 33.683910 | -111.966235 | JW Marriott Phoenix Desert Ridge Resort & Spa | 85054 | 441 | 4.0 | AZ |
| 192602 | 2179 S Green Rd | {'RestaurantsPriceRange2': '2', 'BusinessParking': "{'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False}", 'BusinessAcceptsCreditCards': 'True', 'Caters': 'False', 'BikeParking': 'True'} | NaN | NaN | NaN | NaN | NaN | True | NaN | True | {'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False} | NaN | NaN | NaN | False | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2 | NaN | NaN | NaN | NaN | NaN | NaN | go-_xdHHSufchOeZ3kkC8w | Food, Beer, Wine & Spirits | University Heights | {'Monday': '11:30-21:0', 'Tuesday': '9:0-21:0', 'Wednesday': '9:0-21:0', 'Thursday': '9:0-21:0', 'Friday': '9:0-23:0', 'Saturday': '11:0-23:0', 'Sunday': '13:0-18:0'} | 9:0-23:0 | 11:30-21:0 | 11:0-23:0 | 13:0-18:0 | 9:0-21:0 | 9:0-21:0 | 9:0-21:0 | 0 | 41.500621 | -81.518241 | Cedar Green Wine & Cheese | 44121 | 12 | 3.0 | OH |
| 192603 | 1911 N Cleveland-Massillon Rd | {'OutdoorSeating': 'True', 'BikeParking': 'True', 'WiFi': "u'free'", 'RestaurantsPriceRange2': '3', 'Caters': 'True', 'BusinessParking': "{'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False}", 'RestaurantsDelivery': 'False', 'RestaurantsTakeOut': 'True', 'RestaurantsReservations': 'True', 'RestaurantsAttire': "u'casual'", 'BusinessAcceptsCreditCards': 'True', 'BusinessAcceptsBitcoin': 'False', 'RestaurantsGoodForGroups': 'True', 'Alcohol': "u'full_bar'", 'HasTV': 'True', 'NoiseLevel': "u'average'", 'GoodForKids': 'False', 'Ambience': "{'touristy': False, 'hipster': False, 'romantic': False, 'divey': False, 'intimate': False, 'trendy': False, 'upscale': True, 'classy': False, 'casual': False}"} | NaN | NaN | u'full_bar' | {'touristy': False, 'hipster': False, 'romantic': False, 'divey': False, 'intimate': False, 'trendy': False, 'upscale': True, 'classy': False, 'casual': False} | NaN | True | False | True | {'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False} | NaN | NaN | NaN | True | NaN | NaN | NaN | NaN | NaN | NaN | False | NaN | NaN | NaN | True | NaN | u'average' | NaN | True | u'casual' | NaN | False | True | 3 | True | NaN | True | NaN | NaN | u'free' | p1eUTUB_5hf1enoKYBV3DA | Restaurants, Italian | Bath | {'Monday': '0:0-0:0', 'Tuesday': '17:0-22:0', 'Wednesday': '17:0-22:0', 'Thursday': '17:0-22:0', 'Friday': '17:0-22:0', 'Saturday': '17:0-22:0', 'Sunday': '17:0-22:0'} | 17:0-22:0 | 0:0-0:0 | 17:0-22:0 | 17:0-22:0 | 17:0-22:0 | 17:0-22:0 | 17:0-22:0 | 1 | 41.187547 | -81.635791 | Ken Stewart's Tre Belle | 44210 | 39 | 3.5 | OH |
| 192604 | NaN | {'BusinessAcceptsCreditCards': 'True'} | NaN | NaN | NaN | NaN | NaN | NaN | NaN | True | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | nqb4kWcOwp8bFxzfvaDpZQ | Water Purification Services, Water Heater Installation/Repair, Home Services, Plumbing | North Las Vegas | {'Monday': '0:0-0:0', 'Tuesday': '0:0-0:0', 'Wednesday': '0:0-0:0', 'Thursday': '0:0-0:0', 'Friday': '0:0-0:0', 'Saturday': '0:0-0:0', 'Sunday': '0:0-0:0'} | 0:0-0:0 | 0:0-0:0 | 0:0-0:0 | 0:0-0:0 | 0:0-0:0 | 0:0-0:0 | 0:0-0:0 | 1 | 36.213732 | -115.177059 | Sanderson Plumbing | 89032 | 9 | 5.0 | NV |
| 192605 | 17440 Yonge Street | {'RestaurantsPriceRange2': '2', 'BikeParking': 'True', 'BusinessParking': "{'garage': False, 'street': False, 'validated': False, 'lot': False, 'valet': False}"} | NaN | NaN | NaN | NaN | NaN | True | NaN | NaN | {'garage': False, 'street': False, 'validated': False, 'lot': False, 'valet': False} | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2 | NaN | NaN | NaN | NaN | NaN | NaN | vY2nLU5K20Pee-FdG0br1g | Books, Mags, Music & Video, Shopping | Newmarket | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1 | 44.052658 | -79.481850 | Chapters | L3Y 6Y9 | 3 | 4.5 | ON |
| 192606 | 21230 N 22nd St | {'BusinessAcceptsCreditCards': 'True', 'ByAppointmentOnly': 'False'} | NaN | NaN | NaN | NaN | NaN | NaN | NaN | True | NaN | False | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | MiEyUDKTjeci5TMfxVZPpg | Home Services, Contractors, Landscaping, Masonry/Concrete, Landscape Architects | Phoenix | {'Monday': '7:0-15:0', 'Tuesday': '7:0-15:0', 'Wednesday': '7:0-15:0', 'Thursday': '7:0-15:0', 'Friday': '7:0-15:0'} | 7:0-15:0 | 7:0-15:0 | NaN | NaN | 7:0-15:0 | 7:0-15:0 | 7:0-15:0 | 1 | 33.679992 | -112.035569 | Phoenix Pavers | 85024 | 14 | 4.5 | AZ |
| 192607 | 4406 E Main St | {'RestaurantsPriceRange2': '1', 'BusinessAcceptsCreditCards': 'False', 'BusinessParking': "{'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False}", 'ByAppointmentOnly': 'False', 'BikeParking': 'True'} | NaN | NaN | NaN | NaN | NaN | True | NaN | False | {'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False} | False | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1 | NaN | NaN | NaN | NaN | NaN | NaN | zNMupayB2jEHVDOji8sxoQ | Beauty & Spas, Barbers | Mesa | {'Tuesday': '8:30-17:30', 'Wednesday': '8:30-17:30', 'Thursday': '8:30-17:30', 'Friday': '8:30-17:30', 'Saturday': '7:0-15:0'} | 8:30-17:30 | NaN | 7:0-15:0 | NaN | 8:30-17:30 | 8:30-17:30 | 8:30-17:30 | 1 | 33.416137 | -111.735743 | Beasley's Barber Shop | 85205 | 15 | 4.5 | AZ |
| 192608 | 3735 S Las Vegas Blvd | {'BikeParking': 'False', 'RestaurantsPriceRange2': '1'} | NaN | NaN | NaN | NaN | NaN | False | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1 | NaN | NaN | NaN | NaN | NaN | NaN | c1f_VAX1KIK8-JoVhjbYOw | Massage, Beauty & Spas | Las Vegas | {'Monday': '10:0-0:0', 'Tuesday': '10:0-0:0', 'Wednesday': '10:0-0:0', 'Thursday': '10:0-0:0', 'Friday': '10:0-0:0', 'Saturday': '10:0-0:0', 'Sunday': '10:0-0:0'} | 10:0-0:0 | 10:0-0:0 | 10:0-0:0 | 10:0-0:0 | 10:0-0:0 | 10:0-0:0 | 10:0-0:0 | 0 | 36.107267 | -115.171920 | Oriental Relax | 89109 | 3 | 4.0 | NV |